
<!DOCTYPE html>

<html lang="en">
  <head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>第二章 Excel的快捷操作 &#8212; free-excel</title>
<script>
  document.documentElement.dataset.mode = localStorage.getItem("mode") || "";
  document.documentElement.dataset.theme = localStorage.getItem("theme") || "light"
</script>

  <!-- Loaded before other Sphinx assets -->
  <link href="../_static/styles/theme.css?digest=92025949c220c2e29695" rel="stylesheet">
<link href="../_static/styles/pydata-sphinx-theme.css?digest=92025949c220c2e29695" rel="stylesheet">


  <link rel="stylesheet"
    href="../_static/vendor/fontawesome/5.13.0/css/all.min.css">
  <link rel="preload" as="font" type="font/woff2" crossorigin
    href="../_static/vendor/fontawesome/5.13.0/webfonts/fa-solid-900.woff2">
  <link rel="preload" as="font" type="font/woff2" crossorigin
    href="../_static/vendor/fontawesome/5.13.0/webfonts/fa-brands-400.woff2">

    <link rel="stylesheet" type="text/css" href="../_static/pygments.css" />
    <link rel="stylesheet" type="text/css" href="../_static/css/s4defs-roles.css" />

  <!-- Pre-loaded scripts that we'll load fully later -->
  <link rel="preload" as="script" href="../_static/scripts/pydata-sphinx-theme.js?digest=92025949c220c2e29695">

    <script data-url_root="../" id="documentation_options" src="../_static/documentation_options.js"></script>
    <script src="../_static/jquery.js"></script>
    <script src="../_static/underscore.js"></script>
    <script src="../_static/_sphinx_javascript_frameworks_compat.js"></script>
    <script src="../_static/doctools.js"></script>
    <script src="../_static/sphinx_highlight.js"></script>
    <link rel="shortcut icon" href="../_static/logo.ico"/>
    <link rel="index" title="Index" href="../genindex.html" />
    <link rel="search" title="Search" href="../search.html" />
    <link rel="next" title="第三章 Excel的表合并" href="chap3.html" />
    <link rel="prev" title="第一章 Excel与数据格式" href="chap1.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
  </head>
  
  
  <body data-spy="scroll" data-target="#bd-toc-nav" data-offset="180" data-default-mode="">
    <div class="bd-header-announcement container-fluid" id="banner">
      

    </div>

    
    <nav class="bd-header navbar navbar-light navbar-expand-lg bg-light fixed-top bd-navbar" id="navbar-main"><div class="bd-header__inner container-xl">

  <div id="navbar-start">
    
    
  


<a class="navbar-brand logo" href="../index.html">
  
  
  
  
    <img src="../_static/logo.svg" class="logo__image only-light" alt="Logo image">
    <img src="../_static/logo.svg" class="logo__image only-dark" alt="Logo image">
  
  
</a>
    
  </div>

  <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbar-collapsible" aria-controls="navbar-collapsible" aria-expanded="false" aria-label="Toggle navigation">
    <span class="fas fa-bars"></span>
  </button>

  
  <div id="navbar-collapsible" class="col-lg-9 collapse navbar-collapse">
    <div id="navbar-center" class="mr-auto">
      
      <div class="navbar-center-item">
        <ul id="navbar-main-elements" class="navbar-nav">
    <li class="toctree-l1 nav-item">
 <a class="reference internal nav-link" href="../%E4%B8%BB%E9%A1%B5.html">
  主页
 </a>
</li>

<li class="toctree-l1 current active nav-item">
 <a class="reference internal nav-link" href="index.html">
  教程
 </a>
</li>

<li class="toctree-l1 nav-item">
 <a class="reference internal nav-link" href="../%E4%BD%9C%E8%80%85.html">
  作者
 </a>
</li>

<li class="toctree-l1 nav-item">
 <a class="reference internal nav-link" href="../Datawhale.html">
  Datawhale
 </a>
</li>

<li class="toctree-l1 nav-item">
 <a class="reference internal nav-link" href="../%E7%BB%83%E4%B9%A0%E9%A2%98%E5%8F%82%E8%80%83%E6%93%8D%E4%BD%9C.html">
  练习题参考操作
 </a>
</li>

    
</ul>
      </div>
      
    </div>

    <div id="navbar-end">
      
      <div class="navbar-end-item">
        <span id="theme-switch" class="btn btn-sm btn-outline-primary navbar-btn rounded-circle">
    <a class="theme-switch" data-mode="light"><i class="fas fa-sun"></i></a>
    <a class="theme-switch" data-mode="dark"><i class="far fa-moon"></i></a>
    <a class="theme-switch" data-mode="auto"><i class="fas fa-adjust"></i></a>
</span>
      </div>
      
      <div class="navbar-end-item">
        <ul id="navbar-icon-links" class="navbar-nav" aria-label="Icon Links">
        <li class="nav-item">
          <a class="nav-link" href="https://github.com/datawhalechina/free-excel" rel="noopener" target="_blank" title="GitHub"><span><i class="fab fa-github-square"></i></span>
            <label class="sr-only">GitHub</label></a>
        </li>
      </ul>
      </div>
      
    </div>
  </div>
</div>
    </nav>
    

    <div class="bd-container container-xl">
      <div class="bd-container__inner row">
          

<!-- Only show if we have sidebars configured, else just a small margin  -->
<div class="bd-sidebar-primary col-12 col-md-3 bd-sidebar">
  <div class="sidebar-start-items"><form class="bd-search d-flex align-items-center" action="../search.html" method="get">
  <i class="icon fas fa-search"></i>
  <input type="search" class="form-control" name="q" id="search-input" placeholder="在这里搜索" aria-label="在这里搜索" autocomplete="off" >
</form><nav class="bd-links" id="bd-docs-nav" aria-label="Main navigation">
  <div class="bd-toc-item active">
    <ul class="current nav bd-sidenav">
 <li class="toctree-l1">
  <a class="reference internal" href="chap1.html">
   第一章 Excel与数据格式
  </a>
 </li>
 <li class="toctree-l1 current active">
  <a class="current reference internal" href="#">
   第二章 Excel的快捷操作
  </a>
 </li>
 <li class="toctree-l1">
  <a class="reference internal" href="chap3.html">
   第三章 Excel的表合并
  </a>
 </li>
 <li class="toctree-l1">
  <a class="reference internal" href="chap4.html">
   第四章 Excel函数-逻辑判断
  </a>
 </li>
 <li class="toctree-l1">
  <a class="reference internal" href="chap5.html">
   第五章 Excel函数-文本函数
  </a>
 </li>
 <li class="toctree-l1">
  <a class="reference internal" href="chap6.html">
   第六章 Excel函数-查找函数
  </a>
 </li>
 <li class="toctree-l1">
  <a class="reference internal" href="chap7.html">
   第七章 Excel函数-动态函数
  </a>
 </li>
 <li class="toctree-l1">
  <a class="reference internal" href="chap8.html">
   第八章Excel数据可视化
  </a>
 </li>
 <li class="toctree-l1">
  <a class="reference internal" href="chap9.html">
   第九章Excel数据透视
  </a>
 </li>
 <li class="toctree-l1">
  <a class="reference internal" href="chap10.html">
   第十章Excel看板
  </a>
 </li>
</ul>

  </div>
</nav>
  </div>
  <div class="sidebar-end-items">
  </div>
</div>


          


<div class="bd-sidebar-secondary d-none d-xl-block col-xl-2 bd-toc">
  
    
    <div class="toc-item">
      
<div class="tocsection onthispage mt-5 pt-1 pb-3">
    <i class="fas fa-list"></i> On this page
</div>

<nav id="bd-toc-nav">
    <ul class="visible nav section-nav flex-column">
 <li class="toc-h2 nav-item toc-entry">
  <a class="reference internal nav-link" href="#header-n2">
   1.Excel快捷操作简介
  </a>
  <ul class="nav section-nav flex-column">
   <li class="toc-h3 nav-item toc-entry">
    <a class="reference internal nav-link" href="#header-n9">
     1.1文件相关
    </a>
   </li>
   <li class="toc-h3 nav-item toc-entry">
    <a class="reference internal nav-link" href="#header-n29">
     1.2通用快捷键
    </a>
   </li>
   <li class="toc-h3 nav-item toc-entry">
    <a class="reference internal nav-link" href="#header-n50">
     1.3表格选择
    </a>
   </li>
   <li class="toc-h3 nav-item toc-entry">
    <a class="reference internal nav-link" href="#header-n72">
     1.4单元格编辑
    </a>
   </li>
   <li class="toc-h3 nav-item toc-entry">
    <a class="reference internal nav-link" href="#header-n99">
     1.5Excel格式化
    </a>
   </li>
   <li class="toc-h3 nav-item toc-entry">
    <a class="reference internal nav-link" href="#header-n116">
     1.6Excel公式
    </a>
   </li>
  </ul>
 </li>
 <li class="toc-h2 nav-item toc-entry">
  <a class="reference internal nav-link" href="#header-n3">
   2.Excel快捷操作实践
  </a>
  <ul class="nav section-nav flex-column">
   <li class="toc-h3 nav-item toc-entry">
    <a class="reference internal nav-link" href="#header-n126">
     2.1自动插入求和公式
    </a>
   </li>
   <li class="toc-h3 nav-item toc-entry">
    <a class="reference internal nav-link" href="#header-n4">
     2.2自动进行列差异比对
    </a>
   </li>
   <li class="toc-h3 nav-item toc-entry">
    <a class="reference internal nav-link" href="#header-n137">
     2.3自动填充
    </a>
   </li>
  </ul>
 </li>
 <li class="toc-h2 nav-item toc-entry">
  <a class="reference internal nav-link" href="#header-n167">
   练习
  </a>
 </li>
</ul>

</nav>
    </div>
    
    <div class="toc-item">
      
    </div>
    
  
</div>


          
          
          <div class="bd-content col-12 col-md-9 col-xl-7">
              
              <article class="bd-article" role="main">
                
  <div class="section" id="excel">
<span id="header-n0"></span><h1>第二章 Excel的快捷操作<a class="headerlink" href="#excel" title="Permalink to this heading">#</a></h1>
<blockquote>
<div><p>在本节中我们将了解Excel中的各种快捷操作，目前已知的Excel快捷操作键有230个，本篇重点介绍那些常用的Excel快捷操作键。</p>
</div></blockquote>
<div class="section" id="header-n2">
<span id="id1"></span><h2>1.Excel快捷操作简介<a class="headerlink" href="#header-n2" title="Permalink to this heading">#</a></h2>
<div class="section" id="header-n9">
<span id="id2"></span><h3>1.1文件相关<a class="headerlink" href="#header-n9" title="Permalink to this heading">#</a></h3>
<ul class="simple">
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">N</span></code> 创建一个新的Excel工作簿</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">w</span></code> 关闭当前工作簿</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">S</span></code> 保存当前的Excel工作簿</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">F12</span></code> 将当前文件进行另存为</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">p</span></code> 打印当前工作表</p></li>
</ul>
</div>
<div class="section" id="header-n29">
<span id="id3"></span><h3>1.2通用快捷键<a class="headerlink" href="#header-n29" title="Permalink to this heading">#</a></h3>
<ul class="simple">
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">z</span></code> 撤销当前操作</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">Y</span></code> 恢复撤销，可以用这个快捷键恢复被撤消的操作</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">C</span></code> 复制所选单元格</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">x</span></code> 剪切所选单元格</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">v</span></code> 粘贴所选单元格</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">F</span></code> 弹出查找和替换对话框</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">G</span></code> 显示定位对话框</p></li>
</ul>
</div>
<div class="section" id="header-n50">
<span id="id4"></span><h3>1.3表格选择<a class="headerlink" href="#header-n50" title="Permalink to this heading">#</a></h3>
<ul class="simple">
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">A</span></code> 全选表格</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">→</span></code> 移动到数据区域的右边缘</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">←</span></code> 移动到数据区域的左边缘</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">↑</span></code> 移动到数据区域的上边缘</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">↓</span></code> 移动到数据区域的下边缘</p></li>
</ul>
</div>
<div class="section" id="header-n72">
<span id="id5"></span><h3>1.4单元格编辑<a class="headerlink" href="#header-n72" title="Permalink to this heading">#</a></h3>
<ul class="simple">
<li><p><code class="docutils literal notranslate"><span class="pre">F2</span></code> 编辑当前单元格（跟双击单元格效果一致）</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Alt</span></code> + <code class="docutils literal notranslate"><span class="pre">Enter</span></code> 在当前单元格内换行 (直接按
<code class="docutils literal notranslate"><span class="pre">Enter</span></code>会跳转到下一行)</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Enter</span></code> 下移一个单元格</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Shift</span></code> + <code class="docutils literal notranslate"><span class="pre">Enter</span></code> 上移一个单元格</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Tab</span></code> 右移一个单元格</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Shift</span></code> + <code class="docutils literal notranslate"><span class="pre">Tab</span></code> 左移一个单元格</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">Enter</span></code> 输入完成，并停留在当前单元格</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">;</span></code>（分号） 输入当前日期（显示为年/月/日）</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> +<code class="docutils literal notranslate"><span class="pre">Shift</span></code> + <code class="docutils literal notranslate"><span class="pre">:</span></code> 输入当前时间 (显示为小时/分钟)</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">E</span></code> 快速填充</p></li>
</ul>
</div>
<div class="section" id="header-n99">
<span id="id6"></span><h3>1.5Excel格式化<a class="headerlink" href="#header-n99" title="Permalink to this heading">#</a></h3>
<ul class="simple">
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">1</span></code>（数字1） 设置单元格格式</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">B</span></code> 加粗或取消加粗</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Ctrl</span></code> + <code class="docutils literal notranslate"><span class="pre">i</span></code> 加斜体或取消斜体</p></li>
</ul>
</div>
<div class="section" id="header-n116">
<span id="id7"></span><h3>1.6Excel公式<a class="headerlink" href="#header-n116" title="Permalink to this heading">#</a></h3>
<ul class="simple">
<li><p><code class="docutils literal notranslate"><span class="pre">F4</span></code> 绝对引用和相对引用切换</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">Alt</span></code>+<code class="docutils literal notranslate"><span class="pre">=</span></code> 自动插入求和公式</p></li>
</ul>
</div>
</div>
<div class="section" id="header-n3">
<span id="id8"></span><h2>2.Excel快捷操作实践<a class="headerlink" href="#header-n3" title="Permalink to this heading">#</a></h2>
<div class="section" id="header-n126">
<span id="id9"></span><h3>2.1自动插入求和公式<a class="headerlink" href="#header-n126" title="Permalink to this heading">#</a></h3>
<p>打开文件<code class="docutils literal notranslate"><span class="pre">data/chap2/2.1.xlsx</span></code>，点击【案例1】</p>
<p>1.选中案例1中的表格区域（<strong>注意这里要把汇总的那一行也选上</strong>）</p>
<p>2.使用快捷键<code class="docutils literal notranslate"><span class="pre">Alt</span></code>+<code class="docutils literal notranslate"><span class="pre">=</span></code>
，自动插入求和公式，可以看到，对上述的Excel表格区域进行自动求和。</p>
<div class="figure align-default">
<img alt="" src="../_images/2.1.gif" />
</div>
</div>
<div class="section" id="header-n4">
<span id="id10"></span><h3>2.2自动进行列差异比对<a class="headerlink" href="#header-n4" title="Permalink to this heading">#</a></h3>
<p>打开文件<code class="docutils literal notranslate"><span class="pre">data/chap2/2.2.xlsx</span></code>，点击【案例1】，我们现在的任务是找到1月和2月客户数不同的区域，如何快速定位？</p>
<p>1.选中需要进行列差异比对的区域，注意选择顺序从左往右</p>
<p>2.使用快捷键<code class="docutils literal notranslate"><span class="pre">ctrl</span></code>+<code class="docutils literal notranslate"><span class="pre">\</span></code>
(<strong>注意不是”/”</strong>)，可以快速定位到区域4、区域8以及区域10所对应的客户数不同</p>
<p>3.选择填充颜色，即可快速显示两列的差异</p>
<p>注意这里的选择方向，从右往左选择，那么默认最右边为参考标准，其他列的数据可参考标准比较，如果从左往右选择，那最左边就是参考标准，其他的操作同上。</p>
<div class="figure align-default">
<img alt="" src="../_images/2.2.gif" />
</div>
</div>
<div class="section" id="header-n137">
<span id="id11"></span><h3>2.3自动填充<a class="headerlink" href="#header-n137" title="Permalink to this heading">#</a></h3>
<p>在excel中很多重复、繁琐的工作由数据提取和数据合并这类问题造成，<strong>2013年以后的Excel</strong>支持智能填充，能灵活的解决这类问题。需要注意的是，自动填充的数据需要是同一个规范数据才可以完成自动填充。</p>
<p>打开文件<code class="docutils literal notranslate"><span class="pre">data/chap2/2.3.xlsx</span></code>，点击【案例1】，需要提取客户的手机号</p>
<p>1.手动提取客户1的手机号，并输入到【B2】</p>
<p>2.选择需要快速填充的列，也就是【B2-B11】</p>
<p>3.按<code class="docutils literal notranslate"><span class="pre">ctrl</span></code>+<code class="docutils literal notranslate"><span class="pre">E</span></code>进行自动填充</p>
<div class="figure align-default">
<img alt="" src="../_images/2.31.gif" />
</div>
</div>
</div>
<div class="section" id="header-n167">
<span id="id12"></span><h2>练习<a class="headerlink" href="#header-n167" title="Permalink to this heading">#</a></h2>
<p>1.完成<code class="docutils literal notranslate"><span class="pre">data/chap2/2.1.xlsx</span></code>工作簿中的【案例2】【案例3】的快捷键自动求和任务</p>
<p>2.完成<code class="docutils literal notranslate"><span class="pre">data/chap2/2.2.xlsx</span></code>工作簿中的【案例2】【案例3】的多行快速比对任务（提示：需要选中所有待比对表格框）</p>
<p>3.完成<code class="docutils literal notranslate"><span class="pre">data/chap2/2.3.xlsx</span></code>工作簿中的【案例2】【案例3】【案例4】的填充任务</p>
</div>
</div>


              </article>
              

              
          </div>
          
      </div>
    </div>

  
  
  <!-- Scripts loaded after <body> so the DOM is not blocked -->
  <script src="../_static/scripts/pydata-sphinx-theme.js?digest=92025949c220c2e29695"></script>

<footer class="bd-footer"><div class="bd-footer__inner container">
  
  <div class="footer-item">
    <p class="copyright">
    &copy; Copyright 2022, Datawhale, 牧小熊.<br>
</p>
  </div>
  
  <div class="footer-item">
    <p class="sphinx-version">
Created using <a href="http://sphinx-doc.org/">Sphinx</a> 5.3.0.<br>
</p>
  </div>
  
</div>
</footer>
  </body>
</html>